MySQL remote login settings, mysql Remote Login
You can access the MySQL of another machine on one machine, but some settings are required.
After entering MySQL, enter the following command:
Grant all privileges on *. * TO 'tigase '@' % 'identified
MySQL implements remote login, and mysql implements remote login.
Cause analysis:Host 'local' is not allowed to connect to this MySQL server typical remote permission issues.Problem:
MySQL does not have the permission to enable remote logon. It
Install MySQL1. Download the MySQL Installation FileThe following two files are required to install MYSQL:MySQL-server-5.1.7-0.i386.rpm
To download the above two RPM files, locate the "server" and "client programs" items and find the items
MySQL set remote account login Summary1. ERROR 2003 (HY00 12. ERROR 1045 (28000): Access denied for user ' test ' @ ' x.x.x.x ' (using Password:no) 13. Retrieve the root password and set up Telnet 24. Rror 1062 (23000): Duplicate entry '%-root ' for
MYSQL adds remote users or allows remote access.Add the remote user admin password as password grant all privileges on *. * TO admin @ localhost identified by \ 'password \ 'with grant option grant all privileges on *. * TO admin @ \ "% \"
Install and configure the Mysql database under centos, import the database, authorize a remote ip address, and centos Mysql
Uninstall the original mysql
Because mysql databases are too popular on Linux, the mainstream Linux system versions currently
First, modify the user login password:mysql> show databases;ERROR 1820 (HY000): Must SET PASSWORD before executing this statementMysql> quitBye[[email protected] ~]# mysqladmin-uroot-p password--change user passwordEnter Password:New
Mysql SQL file import commands and mysql remote login instructions in MySQL Qurey Brower direct import *. SQL scripts cannot execute multiple SQL commands at a time. execute the SQL file command in mysql:
Mysql> source d:/myprogram/database/db. SQL;
Introduction: Remote LogonIs an earlier service provided on the Internet. You can use this command to temporarily turn your computer into a terminal for remote computers and directly call Resources and Services of remote computers. The remote login
1, execute command and script on remote host based on password and secret keySsh-t IP "CLI or shell.sh";The 2,C program implements the above functions--based on password-lessPorting the simple C program above to a different system to use the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.